Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CustomerAccountID (FK)(PK) | A unique identifier for a customer account. | ID_CTAC | Identity | integer | |
EffectiveDate | The date and time a CustomerAccount is eligibile to participate in a RebateProgram | DC_EF_DT | Datetime | datetime | |
ExpirationDate | The date and time a CustomerAccount is no longer eligible to participate in a rebate program | DC_EP_DT | Datetime | datetime | |
CumulativePurchaseRebateBasisAmount | The cumulative amount of products and services purchased by a CustomerAccount that is participating in a designated RebateProgram. This covers membership rebate programs that pay "dividends" or issue SVC's or pay cash to customers based on some percentage of a customers total purchases (usually as a monetary value) made over a period of time (usually on an annual basis prescribed in the RebateProgram). | MO_CUM_PCH_RBT_BSS_AMT | Money | decimal(16,5) | |
RebateAccumulationStartDate | The start date of a rebate accumulation period during which customer NET purchases are summarized to use as a basis for calculating a rebate. | DC_RBT_ACCMLTN_SRT_DT | DateCalendar | date | |
RebateAccumulationEndDate | The end date of a rebate accumulation period during which customer NET purchases are summarized to use as a basis for calculating a rebate. | DC_RBT_ACCMLTN_END_DT | DateCalendar | date | |